package cn.edu.hit.education.dao;

import cn.edu.hit.education.pojo.UserSpecialty;
import cn.edu.hit.education.pojo.UserSpecialtyExample;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface UserSpecialtyMapper {
    int countByExample(UserSpecialtyExample example);

    int deleteByExample(UserSpecialtyExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(UserSpecialty record);

    int insertSelective(UserSpecialty record);

    List<UserSpecialty> selectByExample(UserSpecialtyExample example);

    UserSpecialty selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") UserSpecialty record, @Param("example") UserSpecialtyExample example);

    int updateByExample(@Param("record") UserSpecialty record, @Param("example") UserSpecialtyExample example);

    int updateByPrimaryKeySelective(UserSpecialty record);

    int updateByPrimaryKey(UserSpecialty record);
    
    @Select("select specialtyId from user_specialty where userId=#{id}")
	List<Integer> querySpeciatyIdsByUser(Integer id);
    
    
}